﻿CREATE TABLE [dbo].[ArticleSales]
(
	[Id] INT UNIQUE IDENTITY(1,1) NOT NULL,
	[StoreId] [smallint] NOT NULL,
	[ArticleId] [int] NOT NULL,
	[Date] [date] NOT NULL,
	[Units] [int] NOT NULL,
	[Sales] [money] NOT NULL,
	[GM] [money] NOT NULL,
	[GrossSales] [money] NOT NULL,
	[Price] [money] NULL,
	[Confirmed] [bit] NULL,
	[NetMargin] [money] NULL,
	[PIDiffUnits] [int] NULL,
	[PIDiff] [money] NULL,
	[ChargeOffsUnits] [int] NULL,
	[ChargeOffs] [money] NULL,
	[Rebates] [money] NULL,
	[BonusBuyNumber] [varchar](100) NULL,
	[Costs] [money] NULL,
	[CostsWithVat] [money] NULL,
	[Deleted] [bit] NULL
)
